package com.EAsystem.mapper;

import com.EAsystem.entity.Teacher;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface TeacherMapper {
    
    // 插入教师记录
    int insertTeacher(Teacher teacher);
    
    // 更新教师记录
    int updateTeacher(Teacher teacher);
    
    // 根据ID删除教师记录
    int deleteTeacherById(Integer id);
    
    // 根据ID查询教师
    Teacher findTeacherById(Integer id);
    

    
    // 分页查询所有教师
    List<Teacher> findAllTeachersWithPage();

    
    // 根据教师编号查询教师
    Teacher findTeacherByTeacherNo(String teacherNo);
    
    // 根据用户ID查询教师
    Teacher findTeacherByUserId(Integer userId);
    

    
    // 条件查询教师
    List<Teacher> findTeachersByCondition(Teacher teacher);
    

}